How to: Specify multiple criteria in a query.
Solution:
Type criteria in the 'Criteria' and 'or' rows of the query design grid in the Query Design view.
1) If the Database window is not active, activate the Database window.
2) If the query is not open, open the Query Design view.
3) Click in the 'Criteria' row for the desired field in the design grid in the bottom half of the Query Design window.
Criteria row
4) Type the desired criteria.
NOTE 1: Select 'Build...' to have the expression builder help build an expression.
NOTE 2: Type a prompt in brackets for a parameter query.
5) Click in the 'or' row for the same field in the design grid.
NOTE: 'Or' means that one or the other of the defined criteria must be true.
or row
6) Type the desired criteria.
NOTE 1: Select 'Build...' to have the expression builder help build an expression.
NOTE 2: Type a prompt in brackets for a parameter query.
7) Repeat steps 5) and 6) in each 'or' row until the desired number of criteria have been typed for that field.
8) Repeat steps 3) through 7) for each field in the query design grid for which to specify multiple criteria.
NOTE: For a record to be returned by the query, ONE of the criteria specified in the 'Criteria' and 'or' rows must be met.
9) Select the 'File' menu and select 'Save' to save the query.
10) Select the 'File' menu and select 'Close' to close the Query Design view.